<html>
<body>
This script displays all of the database tables and their data.
<?php

mysql_connect("localhost", "root", "") or
    die("Could not connect: " . mysql_error());
mysql_select_db("QA");



$result = mysql_query("Select Client_Number, Staff_Operator, Call_Date, Entry_Timestamp, Reference_Number From Caller");

echo "<TABLE border=1><TR><TD colspan=6 align=center width=100%>QA.Caller Table</TD></TR><TR><TD>Client_Number</TD><TD>Staff_Operator</TD><TD>Call_Date</TD><TD>Entry_Timestamp</TD><TD>Reference_Number</TD></TR>";

while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
	echo "<TR><TD>".$row[0]."</TD><TD>".$row[1]."</TD><TD>".$row[2]."</TD><TD>".$row[3]."</TD><TD>".$row[4]."</TD></TR>";
}

mysql_free_result($result);

echo "<TR><TD colspan=6 align=center width=100%> EOF </TD></TR></TABLE>";



echo "<BR>";



$result = mysql_query("Select Caller_Reference, Reason, Other, Taxonomy, Reference_Number From Unreachable");

echo "<TABLE border=1><TR><TD colspan=6 align=center width=100%>QA.Unreachable Table</TD></TR><TR><TD>Caller_Referencer</TD><TD>Reason</TD><TD>Other</TD><TD>Taxonomy</TD><TD>Reference_Number</TD></TR>";

while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
	echo "<TR><TD>".$row[0]."</TD><TD>".$row[1]."</TD><TD>".$row[2]."</TD><TD>".$row[3]."</TD><TD>".$row[4]."</TD></TR>";
}

mysql_free_result($result);

echo "<TR><TD colspan=6 align=center width=100%> EOF </TD></TR></TABLE>";



echo "<BR>";



$result = mysql_query("Select Reason_Description, Reference_Number From Unreachable_Reasons");

echo "<TABLE border=1><TR><TD colspan=6 align=center width=100%>QA.Unreachable_Reasons Table</TD></TR><TR><TD>Reason_Description</TD><TD>Reference_Number</TD></TR>";

while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
	echo "<TR><TD>".$row[0]."</TD><TD>".$row[1]."</TD></TR>";
}

mysql_free_result($result);

echo "<TR><TD colspan=6 align=center width=100%> EOF </TD></TR></TABLE>";



echo "<BR>";



$result = mysql_query("Select Taxonomy_Description, Reference_Number From Taxonomies");

echo "<TABLE border=1><TR><TD colspan=6 align=center width=100%>QA.Taxonomies Table</TD></TR><TR><TD>Taxonomy_Description</TD><TD>Reference_Number</TD></TR>";

while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
	echo "<TR><TD>".$row[0]."</TD><TD>".$row[1]."</TD></TR>";
}

mysql_free_result($result);

echo "<TR><TD colspan=6 align=center width=100%> EOF </TD></TR></TABLE>";





echo "<BR>";



$result = mysql_query("Select Agency_Description, Reference_Number From Agencies");

echo "<TABLE border=1><TR><TD colspan=6 align=center width=100%>QA.Agencies Table</TD></TR><TR><TD>Agency_Description</TD><TD>Reference_Number</TD></TR>";

while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
	echo "<TR><TD>".$row[0]."</TD><TD>".$row[1]."</TD></TR>";
}

mysql_free_result($result);

echo "<TR><TD colspan=6 align=center width=100%> EOF </TD></TR></TABLE>";






echo "<BR>";



$result = mysql_query("Select Reason_Description, Reference_Number From Unreachable_Reasons");

echo "<TABLE border=1><TR><TD colspan=6 align=center width=100%>QA.Unreachable_Reasons Table</TD></TR><TR><TD>Reason_Description</TD><TD>Reference_Number</TD></TR>";

while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
	echo "<TR><TD>".$row[0]."</TD><TD>".$row[1]."</TD></TR>";
}

mysql_free_result($result);

echo "<TR><TD colspan=6 align=center width=100%> EOF </TD></TR></TABLE>";





echo "<BR>";



$result = mysql_query("Select Treated_Description, Reference_Number From Treated");

echo "<TABLE border=1><TR><TD colspan=6 align=center width=100%>QA.Treated Table</TD></TR><TR><TD>Treated_Description</TD><TD>Reference_Number</TD></TR>";

while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
	echo "<TR><TD>".$row[0]."</TD><TD>".$row[1]."</TD></TR>";
}

mysql_free_result($result);

echo "<TR><TD colspan=6 align=center width=100%> EOF </TD></TR></TABLE>";





echo "<BR>";



$result = mysql_query("Select Time_Description, Reference_Number From Time");

echo "<TABLE border=1><TR><TD colspan=6 align=center width=100%>QA.Time Table</TD></TR><TR><TD>Time_Description</TD><TD>Reference_Number</TD></TR>";

while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
	echo "<TR><TD>".$row[0]."</TD><TD>".$row[1]."</TD></TR>";
}

mysql_free_result($result);

echo "<TR><TD colspan=6 align=center width=100%> EOF </TD></TR></TABLE>";







echo "<BR>";



$result = mysql_query("Select Contacted_Description, Reference_Number From Contacted");

echo "<TABLE border=1><TR><TD colspan=6 align=center width=100%>QA.Contacted Table</TD></TR><TR><TD>Contacted_Description</TD><TD>Reference_Number</TD></TR>";

while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
	echo "<TR><TD>".$row[0]."</TD><TD>".$row[1]."</TD></TR>";
}

mysql_free_result($result);

echo "<TR><TD colspan=6 align=center width=100%> EOF </TD></TR></TABLE>";






echo "<BR>";



$result = mysql_query("Select Assistance_Description, Reference_Number From Assistance");

echo "<TABLE border=1><TR><TD colspan=6 align=center width=100%>QA.Assistance Table</TD></TR><TR><TD>Assistance_Description</TD><TD>Reference_Number</TD></TR>";

while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
	echo "<TR><TD>".$row[0]."</TD><TD>".$row[1]."</TD></TR>";
}

//mysql_free_result($result);

echo "<TR><TD colspan=6 align=center width=100%> EOF </TD></TR></TABLE>";




echo "<BR>";



$result = mysql_query("Select Caller_Reference, Met, Taxonomy, Reference_Number From Needs");

echo "<TABLE border=1><TR><TD colspan=6 align=center width=100%>QA.Needs Table</TD></TR><TR><TD>Caller_Reference</TD><TD>Met</TD><TD>Taxonomy</TD><TD>Reference_Number</TD></TR>";

while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
	echo "<TR><TD>".$row[0]."</TD><TD>".$row[1]."</TD><TD>".$row[2]."</TD><TD>".$row[3]."</TD></TR>";
}

mysql_free_result($result);

echo "<TR><TD colspan=6 align=center width=100%> EOF </TD></TR></TABLE>";





$result = mysql_query("Select Refer_Description, Reference_Number From Refer");

echo "<TABLE border=1><TR><TD colspan=6 align=center width=100%>QA.Refer Table</TD></TR><TR><TD>Refer_Description</TD><TD>Reference_Number</TD></TR>";

while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
	echo "<TR><TD>".$row[0]."</TD><TD>".$row[1]."</TD></TR>";
}

mysql_free_result($result);

echo "<TR><TD colspan=6 align=center width=100%> EOF </TD></TR></TABLE>";




$result = mysql_query("Select Caller_Reference, Agency, Taxonomy, Contacted, Time, Assistance, Explanation, Treated, Reference_Number From AgencyFeedback");

echo "<TABLE border=1><TR><TD colspan=9 align=center width=100%>QA.AgencyFeedback Table</TD></TR><TR><TD>Caller_Reference</TD><TD>Agency</TD><TD>Taxonomy</TD><TD>Contacted</TD><TD>Time</TD><TD>Assistance</TD><TD>Explanation</TD><TD>Treated</TD><TD>Reference_Number</TD></TR>";

while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
	echo "<TR><TD>".$row[0]."</TD><TD>".$row[1]."</TD><TD>".$row[2]."</TD><TD>".$row[3]."</TD><TD>".$row[4]."</TD><TD>".$row[5]."</TD><TD>".$row[6]."</TD><TD>".$row[7]."</TD><TD>".$row[8]."</TD></TR>";
}

mysql_free_result($result);

echo "<TR><TD colspan=9 align=center width=100%> EOF </TD></TR></TABLE>";




$result = mysql_query("Select Caller_Reference, Appropriate, Refer, Comments, Reference_Number From 211Feedback");

echo "<TABLE border=1><TR><TD colspan=5 align=center width=100%>QA.211Feedback Table</TD></TR><TR><TD>Caller_Reference</TD><TD>Appropriate</TD><TD>Refer</TD><TD>Comments</TD><TD>Reference_Number</TD></TR>";

while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
	echo "<TR><TD>".$row[0]."</TD><TD>".$row[1]."</TD><TD>".$row[2]."</TD><TD>".$row[3]."</TD><TD>".$row[4]."</TD></TR>";
}

mysql_free_result($result);

echo "<TR><TD colspan=5 align=center width=100%> EOF </TD></TR></TABLE>";




?>
<br>
</body>
</html>